<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_supplier_category`;");
E_C("CREATE TABLE `ecs_supplier_category` (
  `cat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(90) NOT NULL DEFAULT '',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `cat_desc` varchar(255) NOT NULL DEFAULT '',
  `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `sort_order` tinyint(1) unsigned NOT NULL DEFAULT '50',
  `template_file` varchar(50) NOT NULL DEFAULT '',
  `measure_unit` varchar(15) NOT NULL DEFAULT '',
  `show_in_nav` tinyint(1) NOT NULL DEFAULT '0',
  `style` varchar(150) NOT NULL,
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `grade` tinyint(4) NOT NULL DEFAULT '0',
  `filter_attr` varchar(255) NOT NULL DEFAULT '0',
  `supplier_id` int(10) unsigned NOT NULL DEFAULT '0',
  `is_show_cat_pic` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cat_pic` varchar(255) NOT NULL DEFAULT '',
  `cat_pic_url` varchar(100) NOT NULL DEFAULT '',
  `cat_goods_limit` smallint(3) unsigned NOT NULL DEFAULT '4',
  PRIMARY KEY (`cat_id`),
  KEY `parent_id` (`parent_id`,`supplier_id`),
  KEY `supplier_id` (`supplier_id`)
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_supplier_category` values('1','上装','上装','','0','50','','','1','','1','4','6','3','1','../data/supplier/category/3c1411025072.jpg','','8');");
E_D("replace into `ecs_supplier_category` values('2','下装','','','0','50','','','1','','1','5','9,10,8','3','0','../data/supplier/category/3c1411025444.jpg','','8');");
E_D("replace into `ecs_supplier_category` values('3','配饰','配饰','','0','50','','','1','','1','6','6,10,8','3','0','../data/supplier/category/3c1411025553.jpg','','8');");
E_D("replace into `ecs_supplier_category` values('4','T恤','','','1','50','','','1','','1','4','9','3','0','','','8');");
E_D("replace into `ecs_supplier_category` values('5','外套/西装','','','1','50','','','1','','1','5','10,6','3','1','','','8');");
E_D("replace into `ecs_supplier_category` values('6','衬衫','','','1','50','','','1','','1','5','9,8','3','1','','','8');");
E_D("replace into `ecs_supplier_category` values('7','牛仔裤','','','2','50','','','1','','1','6','10,9','3','0','','','8');");
E_D("replace into `ecs_supplier_category` values('8','连衣裙','','','2','50','','','1','','1','5','8,9','3','0','','','8');");
E_D("replace into `ecs_supplier_category` values('9','帆布鞋','','','3','50','','','0','','1','5','13,18','3','0','','','8');");
E_D("replace into `ecs_supplier_category` values('10','项链','','','3','50','','','1','','1','5','','3','0','','','8');");
E_D("replace into `ecs_supplier_category` values('11','半身裙','','','2','50','','','1','','1','5','9,8','3','0','','','8');");
E_D("replace into `ecs_supplier_category` values('12','裙装','','','0','50','','','1','','1','5','6,10,9,8,7','1','0','../data/supplier/category/1c1411027785.jpg','','4');");
E_D("replace into `ecs_supplier_category` values('13','裙装','','','0','50','','','1','','1','0','6','2','0','../data/supplier/category/2c1411027721.png','','8');");
E_D("replace into `ecs_supplier_category` values('14','连衣裙','','','12','2','','','0','','1','0','6,10,9,8,7','1','1','../data/supplier/category/1c1411029905.jpg','','4');");
E_D("replace into `ecs_supplier_category` values('15','半身裙','','','12','50','','','1','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('16','毛呢裙','','','12','50','','','0','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('17','外套','','','0','50','','','1','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('18','风衣','','','17','50','','','1','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('19','大衣','','','17','50','','','0','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('20','羽绒服','','','17','50','','','1','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('21','下装','','','0','50','','','1','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('22','牛仔裤','','','21','50','','','0','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('23','西裤','','','21','50','','','0','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('24','热裤','','','21','50','','','1','','1','0','','1','0','','','8');");
E_D("replace into `ecs_supplier_category` values('25','上装','','','0','50','','','1','','1','0','6','2','0','../data/supplier/category/2c1411028470.png','','8');");
E_D("replace into `ecs_supplier_category` values('26','裤装','','','0','50','','','0','','1','0','6','2','0','','','8');");
E_D("replace into `ecs_supplier_category` values('27','连衣裙','','','13','50','','','0','','1','0','','2','0','','','8');");
E_D("replace into `ecs_supplier_category` values('28','雪纺裙','','','13','50','','','1','','1','0','','2','1','../data/supplier/category/2c1411032949.png','','8');");
E_D("replace into `ecs_supplier_category` values('29','棉麻裙','','','13','50','','','0','','0','0','','2','1','','','8');");
E_D("replace into `ecs_supplier_category` values('30','T恤','','','25','50','','','0','','1','0','','2','0','','','8');");
E_D("replace into `ecs_supplier_category` values('31','衬衫','','','25','50','','','1','','1','0','','2','1','','','8');");
E_D("replace into `ecs_supplier_category` values('32','西装','','','25','50','','','0','','1','0','','2','0','','','8');");
E_D("replace into `ecs_supplier_category` values('33','休闲裤','','','26','50','','','0','','1','0','','2','0','','','8');");
E_D("replace into `ecs_supplier_category` values('34','打底裤','','','26','50','','','0','','1','0','','2','0','','','8');");
E_D("replace into `ecs_supplier_category` values('35','牛仔裤','','','26','50','','','0','','1','0','','2','0','','','8');");
E_D("replace into `ecs_supplier_category` values('36','商品分类1','','','0','50','','','1','','1','0','','9','0','','','8');");
E_D("replace into `ecs_supplier_category` values('37','包','','','0','50','','100','0','','1','0','','19','1','../data/supplier/category/19c1417771669.jpg','','8');");
E_D("replace into `ecs_supplier_category` values('38','男包','','','37','50','','100','0','','1','0','','19','0','','','8');");
E_D("replace into `ecs_supplier_category` values('39','女包','','','37','50','','100','1','','1','0','','19','1','','','8');");
E_D("replace into `ecs_supplier_category` values('40','女包','女包','女包','0','50','','个','1','','1','0','','18','1','','','8');");
E_D("replace into `ecs_supplier_category` values('41','男包','男包','男包','0','50','','个','1','','1','0','','18','1','','','8');");
E_D("replace into `ecs_supplier_category` values('42','男装','','','0','50','','','1','','1','3','6,13','21','0','','','8');");
E_D("replace into `ecs_supplier_category` values('43','女装','','','0','50','','','1','','1','4','9,18','21','0','../data/supplier/category/21c1417773839.jpg','','8');");
E_D("replace into `ecs_supplier_category` values('44','外套','','','42','50','','','1','','1','4','7,17','21','1','','','8');");
E_D("replace into `ecs_supplier_category` values('45','时尚箱包','','','0','1','','','1','','1','4','6','22','1','','','8');");
E_D("replace into `ecs_supplier_category` values('46','精品男包','','','45','50','','','1','','1','4','19','22','0','','','8');");
E_D("replace into `ecs_supplier_category` values('47','商务男包','','','45','50','','','1','','1','3','10','22','0','','','8');");

require("../../inc/footer.php");
?>